I'm writing this while in hiding at the PASS Data Community Summit that's taking place in Seattle this week. I just had a real surprise, finding out that DocumentDB is PostgreSQL under the covers and always has been. However, as much as I enjoy talking PostgreSQL, for the moment, I'll shut up about it. Instead, […]
Learn about unlogged tables and how they work in PostgreSQL.
JSON is a complex data type used for representing objects with various properties. With JSON you follow the key-value pattern where the key is a string and the value can be of different data types. What are some common ways to work with JSON in SQL Server?
SQL Server 2025 has been released to GA. Read about the new version in this piece by Bob Ward.
Today we have a guest editorial reminding us that business knowledge is important, and we could all use some training.
If you’re a SQL Server DBA or developer looking to harness AI for your everyday scripting workflows, this article will walk you through building an AI-powered T-SQL assistant using Python and SQL Server.
AI can help us do more, but do we need to do more? Or more importantly, are we doing a good job of producing more useful stuff?
In this quarter’s update of our SQL ConstantCare® population report, showing how quickly (or slowly) folks adopt new versions of SQL Server, the data is very similar to last quarter
Introduction When you’re running MongoDB at scale with data distributed across multiple Pure Storage...
By Brian Kelley
If you're an attendee at the PASS Data Community Summit this year, there are...
By Steve Jones
dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would...
Hi there I am seeking some help with an SQL statement. Any help would...
Comments posted to this topic are about the item Personal Contact Is Vital
Comments posted to this topic are about the item Getting the Schema for Tables
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; GOSee possible answers